SUPPORT / SAMPLES & SAS NOTES
Problem Note 40656: The error "Parsing did not find expected..." occurs when you are rendering a crosstabulation table in SAS® Web Report Studio
 |  |  |  |  |
In SAS Web Report Studio, you might see an error message that is similar to the following:
An error occurred in processing the report element. Please refresh the page to
try again. Contact your administrator if this problem persists.
....
Root Cause: com.sas.iquery.metadata.expr.iqtextparser.ParseError: parsing did
not find expected a number, text, name, resource, function, case expression, or
an open parenthesis '('. Current parse failed at index 35 w/token '.' (DOT).
Parsed so far [CASE, WHEN, <>, >, 0, and, ABS, (, <>, +, <>, ), >, 0, THEN, (,
<>, +, <>, ), /, <>, WHEN, ABS, (, <>, +, <>, ), >, 0, THEN, 0, ELSE, .]
at
com.sas.iquery.metadata.expr.iqtextparser.NodeParserImpl.parseerror(NodeParserIm
pl.java:334)
....This error can occur if the report includes a data item with a case expression that identifies missing values and the aggregation type is Defined in expression (non-additive).
As a workaround, you can upgrade to the third maintenance release for SAS 9.2 (TS2M3) and change the aggregation for the data item to Defined in expression (additive).
Click the Hot Fix tab in this note to access the hot fix for this issue. After the hot fix is applied to version 4.2_M2, you can use either Defined in expression (additive) or Defined in expression (non-additive) as the expression type.
This error does not occur in version 3.1.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Web Report Studio | z/OS | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft® Windows® for x64 | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 for x64 | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2008 for x64 | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows XP Professional | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Windows Vista | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Windows Vista for x64 | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| 64-bit Enabled AIX | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| 64-bit Enabled Solaris | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| HP-UX IPF | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Linux for x64 | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Solaris for x64 | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||